[dbo].[sp_asi_UpdateDupMatchKey]

Property	Value
ANSI Nulls On
Quoted Identifier On

SQL Script

/****** Object:  StoredProcedure dbo.sp_asi_UpdateDupMatchKey  ******/
-- =============================================
-- This stored procedure calculates the Name.DUP_MATCH_KEY value - update the formula as required
-- =============================================
create procedure dbo.sp_asi_UpdateDupMatchKey
as
begin
     -- controls update messages being sent to display
     set nocount on
     update Name
         set DUP_MATCH_KEY=dbo.fn_asi_GetDupMatchKey(ID)
         where DUP_MATCH_KEY<>dbo.fn_asi_GetDupMatchKey(ID)
end
GRANT EXECUTE on fn_asi_convert_foreign_chars to IMIS

GO